{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["TITULAR","TITULAR + CONYUGE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TITULAR","index":0,"n_rows":98,"n_cols":21,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Monto Solicitado",60000,null,null,null,null,null,null,null,"Sí"]
[null,"Seguro de Vida",{"$f":"+IF(C9=\"Sí\",1.34%,3.3%)","v":3.3000000000000002E-2}]
[null,"Monto adicional Seguro Vida",{"$f":"+C3*C2","v":1980}]
[null,"Monto a Financiar",{"$f":"+C2+C4","v":61980}]
[null,"Seguro Desempleo",0,null,null,null,null,null,null,null,"No"]
[null,"Monto adicional desempleo",{"$f":"C6*C5","v":0}]
[null,"MAF Total",{"$f":"C7+C5","v":61980}]
[null,"Empleado","No"]
[null,"Moneda","Soles"]
[null,"Plazo Remanente",12]
[null,"Fecha de Desembolso","2022-03-17"]
[null,"Fecha de 1er Pago","2022-04-16"]
[null,"Cuota Julio",1]
[null,"Cuota Diciembre",1]
[null,"TEA",0.45]
[null,"TEA TOTAL",{"$f":"+C16","v":0.45}]
[null,"Monto del Bien",0]
[null,"Seguro del Bien",0]
[null,"Portes",0]
[null,"Cuota",{"$f":"(C8+((C19*C18)+C20)*P25)/O25","v":6297.7147799121731}]
[]
[null,"TCEA",0.54433675271645954]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C8-U25-C7-C4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O27:O98)","v":9.84166513823358},{"$f":"SUM(P27:P98)","v":9.84166513823358},null,null,null,null,{"$f":"SUM(U27:U98)","v":60000}]
[null,"N° Cuota","Fecha de pago","Día","Fecha de pago","Días","Dias Acumulados","Saldo Inicial","Amortización","Interés","Seguro del Bien","Portes","Cuota Constante","Saldo Final","Factor Cronograma","Factor Cronograma 2",null,"Vector i,1\nCuota","Vector i,2\nDías Acum","Vector i,3 Factor","Vector i,4\nCalculo VA"]
[null,1,{"$f":"C13","v":"2022-04-16"},{"$f":"IF(B27<=$C$11,WEEKDAY(C27,2),\"\")","v":6},{"$f":"IF(D27=7,C27+1,C27)","v":"2022-04-16"},{"$f":"E27-C12","v":30},{"$f":"F27","v":30},{"$f":"C8","v":61980},{"$f":"IF(B27>C$11,\"\",M27-L27-K27-J27)","v":4348.5684133677478},{"$f":"IF(B27>C$11,\"\",((1+C$16)^(F27/360)-1)*H27)","v":1949.1463665444248},{"$f":"IF(B27>C$11,\"\",C$18*C$19)","v":0},{"$f":"IF(B27>C$11,\"\",C$20)","v":0},{"$f":"IF(B27>C$11,\"\",IF(B27=C$11,H27+J27+K27+L27,IF(AND(C$14=2,MONTH(E27)=7),2*C$21,IF(AND(C$15=2,MONTH(E27)=12),2*C$21,C$21))))","v":6297.7147799121731},{"$f":"IF(B27>C$11,\"\",H27-I27)","v":57631.43158663225},{"$f":"IFERROR(IF(AND(MONTH(E27)=7,C$14=2),2/(1+C$17)^(G27/360),IF(AND(MONTH(E27)=12,C$15=2),2/(1+C$17)^(G27/360),1/(1+C$17)^(G27/360))),\"\")","v":0.96951083383205539},{"$f":"IFERROR(1/(1+C$17)^(G27/360),\"\")","v":0.96951083383205539},null,{"$f":"IFERROR(I27+J27+K27+L27,\"\")","v":6297.7147799121722},{"$f":"G27","v":30},{"$f":"IFERROR((1+C$23)^(S27/360),\"\")","v":1.0368800071126967},{"$f":"IFERROR(ROUND(R27/T27,2),\"\")","v":6073.72}]
[null,2,{"$f":"IF(B28>$C$11,\"\",EDATE(C27,1))","v":"2022-05-16"},{"$f":"IF(B28<=$C$11,WEEKDAY(C28,2),\"\")","v":1},{"$f":"IF(D28=7,C28+1,C28)","v":"2022-05-16"},{"$f":"IF(B28>C$11,\"\",E28-E27)","v":30},{"$f":"IFERROR(F28+G27,\"\")","v":60},{"$f":"IF(B28>C$11,\"\",N27)","v":57631.43158663225},{"$f":"IF(B28>C$11,\"\",M28-L28-K28-J28)","v":4485.3221455811336},1812.3926343310397,0,0,{"$f":"IF(B28>C$11,\"\",IF(B28=C$11,H28+J28+K28+L28,IF(AND(C$14=2,MONTH(E28)=7),2*C$21,IF(AND(C$15=2,MONTH(E28)=12),2*C$21,C$21))))","v":6297.7147799121731},53146.109441051114,0.9399512569177273,0.9399512569177273,null,{"$f":"IFERROR(I28+J28+K28+L28,\"\")","v":6297.7147799121731},60,1.0751201491500257,5857.68]
[null,3,"2022-06-16",4,"2022-06-16",{"$f":"IF(B29>C$11,\"\",E29-E28)","v":31},91,53146.109441051114,4569.7690614296489,1727.9457184825239,0,0,6297.7147799121731,48576.340379621462,0.91035284751912682,0.91035284751912682,null,6297.7147799121731,91,1.1161171594234467,5642.52]
[null,4,"2022-07-16",6,"2022-07-16",30,121,48576.340379621462,4770.0865554693792,1527.6282244427944,0,0,6297.7147799121731,43806.253824152082,0.88259694827965451,0.88259694827965451,null,6297.714779912174,121,1.1572795682015862,5441.83]
[null,5,"2022-08-16",2,"2022-08-16",31,152,43806.253824152082,4873.4368876205108,1424.2778922916621,0,0,6297.7147799121731,38932.81693653157,0.85480458605142562,0.85480458605142562,null,6297.7147799121731,152,1.2014095218484317,5241.9399999999996]
[null,6,"2022-09-16",5,"2022-09-16",31,183,38932.81693653157,5031.8875153865783,1265.8272645255947,0,0,6297.7147799121731,33900.929421144989,0.82788738592264743,0.82788738592264743,null,6297.7147799121731,183,1.24722226059093,5049.3900000000003]
[null,7,"2022-10-16",7,"2022-10-17",31,214,33900.929421144989,5195.4898670834991,1102.2249128286735,0,0,6297.7147799121731,28705.43955406149,0.80181778964929473,0.80181778964929473,null,6297.7147799121722,214,1.294781953217945,4863.92]
[null,8,"2022-11-16",3,"2022-11-16",30,244,28705.43955406149,5394.9864287205055,902.72835119166768,0,0,6297.7147799121731,23310.453125340984,0.7773710338242632,0.7773710338242632,null,6297.7147799121731,244,1.3425335208620139,4690.92]
[null,9,"2022-12-16",5,"2022-12-16",30,274,23310.453125340984,5564.647903310648,733.06687660152488,0,0,6297.7147799121731,17745.805222030336,0.75366963919984831,0.75366963919984831,null,6297.7147799121731,274,1.3920461666604387,4524.07]
[null,10,"2023-01-16",1,"2023-01-16",31,305,17745.805222030336,5720.7433237335426,576.97145617863066,0,0,6297.7147799121731,12025.061898296794,0.72993710799872769,0.72993710799872769,null,6297.7147799121731,305,1.4451283556983547,4357.8900000000003]
[null,11,"2023-02-16",4,"2023-02-16",31,336,12025.061898296794,5906.7425254953814,390.97225441679143,0,0,6297.7147799121731,6118.3193728014121,0.70695189765002997,0.70695189765002997,null,6297.7147799121731,336,1.5002347008745811,4197.82]
[null,12,"2023-03-16",4,"2023-03-16",28,364,6118.3193728014121,6118.3193728014121,179.3954071107149,0,0,6297.7147799121267,0,0.68681381138878006,0.68681381138878006,null,6297.7147799121267,364,1.5518121235887719,4058.3]
[null,13,"","","","","","","","","","","","","","",null,"","","",""]
[null,14,"","","","","","","","","","","","","","",null,"","","",""]
[null,15,"","","","","","","","","","","","","","",null,"","","",""]
[null,16,"","","","","","","","","","","","","","",null,"","","",""]
[null,17,"","","","","","","","","","","","","","",null,"","","",""]
[null,18,"","","","","","","","","","","","","","",null,"","","",""]
[null,19,"","","","","","","","","","","","","","",null,"","","",""]
[null,20,"","","","","","","","","","","","","","",null,"","","",""]
[null,21,"","","","","","","","","","","","","","",null,"","","",""]
[null,22,"","","","","","","","","","","","","","",null,"","","",""]
[null,23,"","","","","","","","","","","","","","",null,"","","",""]
[null,24,"","","","","","","","","","","","","","",null,"","","",""]
[null,25,"","","","","","","","","","","","","","",null,"","","",""]
[null,26,"","","","","","","","","","","","","","",null,"","","",""]
[null,27,"","","","","","","","","","","","","","",null,"","","",""]
[null,28,"","","","","","","","","","","","","","",null,"","","",""]
[null,29,"","","","","","","","","","","","","","",null,"","","",""]
[null,30,"","","","","","","","","","","","","","",null,"","","",""]
[null,31,"","","","","","","","","","","","","","",null,"","","",""]
[null,32,"","","","","","","","","","","","","","",null,"","","",""]
[null,33,"","","","","","","","","","","","","","",null,"","","",""]
[null,34,"","","","","","","","","","","","","","",null,"","","",""]
[null,35,"","","","","","","","","","","","","","",null,"","","",""]
[null,36,"","","","","","","","","","","","","","",null,"","","",""]
[null,37,"","","","","","","","","","","","","","",null,"","","",""]
[null,38,"","","","","","","","","","","","","","",null,"","","",""]
[null,39,"","","","","","","","","","","","","","",null,"","","",""]
[null,40,"","","","","","","","","","","","","","",null,"","","",""]
[null,41,"","","","","","","","","","","","","","",null,"","","",""]
[null,42,"","","","","","","","","","","","","","",null,"","","",""]
[null,43,"","","","","","","","","","","","","","",null,"","","",""]
[null,44,"","","","","","","","","","","","","","",null,"","","",""]
[null,45,"","","","","","","","","","","","","","",null,"","","",""]
[null,46,"","","","","","","","","","","","","","",null,"","","",""]
[null,47,"","","","","","","","","","","","","","",null,"","","",""]
[null,48,"","","","","","","","","","","","","","",null,"","","",""]
[null,49,"","","","","","","","","","","","","","",null,"","","",""]
[null,50,"","","","","","","","","","","","","","",null,"","","",""]
[null,51,"","","","","","","","","","","","","","",null,"","","",""]
[null,52,"","","","","","","","","","","","","","",null,"","","",""]
[null,53,"","","","","","","","","","","","","","",null,"","","",""]
[null,54,"","","","","","","","","","","","","","",null,"","","",""]
[null,55,"","","","","","","","","","","","","","",null,"","","",""]
[null,56,"","","","","","","","","","","","","","",null,"","","",""]
[null,57,"","","","","","","","","","","","","","",null,"","","",""]
[null,58,"","","","","","","","","","","","","","",null,"","","",""]
[null,59,"","","","","","","","","","","","","","",null,"","","",""]
[null,60,"","","","","","","","","","","","","","",null,"","","",""]
[null,61,"","","","","","","","","","","","","","",null,"","","",""]
[null,62,"","","","","","","","","","","","","","",null,"","","",""]
[null,63,"","","","","","","","","","","","","","",null,"","","",""]
[null,64,"","","","","","","","","","","","","","",null,"","","",""]
[null,65,"",{"$f":"IF(B91<=$C$11,WEEKDAY(C91,2),\"\")","v":""},"","","","","",{"$f":"IF(B91>C$11,\"\",((1+C$16)^(F91/360)-1)*H91)","v":""},{"$f":"IF(B91>C$11,\"\",C$18*C$19)","v":""},{"$f":"IF(B91>C$11,\"\",C$20)","v":""},"",{"$f":"IF(B91>C$11,\"\",H91-I91)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E91)=7,C$14=2),2/(1+C$17)^(G91/360),IF(AND(MONTH(E91)=12,C$15=2),2/(1+C$17)^(G91/360),1/(1+C$17)^(G91/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$17)^(G91/360),\"\")","v":""},null,"",{"$f":"G91","v":""},{"$f":"IFERROR((1+C$23)^(S91/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R91/T91,2),\"\")","v":""}]
[null,66,{"$f":"IF(B92>$C$11,\"\",EDATE(C91,1))","v":""},"",{"$f":"IF(D92=7,C92+1,C92)","v":""},{"$f":"IF(B92>C$11,\"\",E92-E91)","v":""},{"$f":"IFERROR(F92+G91,\"\")","v":""},{"$f":"IF(B92>C$11,\"\",N91)","v":""},{"$f":"IF(B92>C$11,\"\",M92-L92-K92-J92)","v":""},"","","",{"$f":"IF(B92>C$11,\"\",IF(B92=C$11,H92+J92+K92+L92,IF(AND(C$14=2,MONTH(E92)=7),2*C$21,IF(AND(C$15=2,MONTH(E92)=12),2*C$21,C$21))))","v":""},"","","",null,{"$f":"IFERROR(I92+J92+K92+L92,\"\")","v":""},"","",""]
[null,67,"","","","","","","","","","","","","","",null,"","","",""]
[null,68,"","","","","","","","","","","","","","",null,"","","",""]
[null,69,"","","","","","","","","","","","","","",null,"","","",""]
[null,70,"","","","","","","","","","","","","","",null,"","","",""]
[null,71,"","","","","","","","","","","","","","",null,"","","",""]
[null,72,"","","","","","","","","","","","","","",null,"","","",""]

{"sheet":"TITULAR + CONYUGE","index":1,"n_rows":98,"n_cols":21,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Monto Solicitado",0,null,null,null,null,null,null,null,"Sí"]
[null,"Seguro de Vida",{"$f":"+IF(C9=\"Sí\",2.68%,6.6%)","v":6.6000000000000003E-2}]
[null,"Monto adicional Seguro Vida",{"$f":"+C3*C2","v":0}]
[null,"Monto a Financiar",{"$f":"+C2+C4","v":0}]
[null,"Seguro Desempleo",0,null,null,null,null,null,null,null,"No"]
[null,"Monto adicional desempleo",{"$f":"C6*C5","v":0}]
[null,"MAF Total",{"$f":"C7+C5","v":0}]
[null,"Empleado","No"]
[null,"Moneda","Soles"]
[null,"Plazo Remanente",0]
[null,"Fecha de Desembolso",{"$f":"TODAY()","v":"2022-03-17"}]
[null,"Fecha de 1er Pago",{"$f":"EDATE(C12,1)","v":"2022-04-17"}]
[null,"Cuota Julio",1]
[null,"Cuota Diciembre",1]
[null,"TEA",0]
[null,"TEA TOTAL",{"$f":"+C16","v":0}]
[null,"Monto del Bien",0]
[null,"Seguro del Bien",0]
[null,"Portes",0]
[null,"Cuota",{"$f":"(C8+(C19*C18+C20)*P25)/O25","v":0}]
[]
[null,"TCEA",0.16941779982252866]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C8-U25-C7-C4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O27:O98)","v":1},{"$f":"SUM(P27:P98)","v":1},null,null,null,null,{"$f":"SUM(U27:U98)","v":0}]
[null,"N° Cuota","Fecha de pago","Día","Fecha de pago","Días","Dias Acumulados","Saldo Inicial","Amortización","Interés","Seguro del Bien","Portes","Cuota Constante","Saldo Final","Factor Cronograma","Factor Cronograma 2",null,"Vector i,1\nCuota","Vector i,2\nDías Acum","Vector i,3 Factor","Vector i,4\nCalculo VA"]
[null,1,{"$f":"C13","v":"2022-04-17"},{"$f":"IF(B27<=$C$11,WEEKDAY(C27,2),\"\")","v":""},{"$f":"IF(D27=7,C27+1,C27)","v":"2022-04-17"},{"$f":"E27-C12","v":31},{"$f":"F27","v":31},{"$f":"C8","v":0},{"$f":"IF(B27>C$11,\"\",M27-L27-K27-J27)","v":""},{"$f":"IF(B27>C$11,\"\",((1+C$16)^(F27/360)-1)*H27)","v":""},{"$f":"IF(B27>C$11,\"\",C$18*C$19)","v":""},{"$f":"IF(B27>C$11,\"\",C$20)","v":""},{"$f":"IF(B27>C$11,\"\",IF(B27=C$11,H27+J27+K27+L27,IF(AND(C$14=2,MONTH(E27)=7),2*C$21,IF(AND(C$15=2,MONTH(E27)=12),2*C$21,C$21))))","v":""},{"$f":"IF(B27>C$11,\"\",H27-I27)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E27)=7,C$14=2),2/(1+C$17)^(G27/360),IF(AND(MONTH(E27)=12,C$15=2),2/(1+C$17)^(G27/360),1/(1+C$17)^(G27/360))),\"\")","v":1},{"$f":"IFERROR(1/(1+C$17)^(G27/360),\"\")","v":1},null,{"$f":"IFERROR(I27+J27+K27+L27,\"\")","v":""},{"$f":"G27","v":31},{"$f":"IFERROR((1+C$23)^(S27/360),\"\")","v":1.0135681299557451},{"$f":"IFERROR(ROUND(R27/T27,2),\"\")","v":""}]
[null,2,{"$f":"IF(B28>$C$11,\"\",EDATE(C27,1))","v":""},"",{"$f":"IF(D28=7,C28+1,C28)","v":""},{"$f":"IF(B28>C$11,\"\",E28-E27)","v":""},{"$f":"IFERROR(F28+G27,\"\")","v":""},{"$f":"IF(B28>C$11,\"\",N27)","v":""},{"$f":"IF(B28>C$11,\"\",M28-L28-K28-J28)","v":""},"","","",{"$f":"IF(B28>C$11,\"\",IF(B28=C$11,H28+J28+K28+L28,IF(AND(C$14=2,MONTH(E28)=7),2*C$21,IF(AND(C$15=2,MONTH(E28)=12),2*C$21,C$21))))","v":""},"","","",null,{"$f":"IFERROR(I28+J28+K28+L28,\"\")","v":""},"","",""]
[null,3,"","","","","","","","","","","","","","",null,"","","",""]
[null,4,"","","","","","","","","","","","","","",null,"","","",""]
[null,5,"","","","","","","","","","","","","","",null,"","","",""]
[null,6,"","","","","","","","","","","","","","",null,"","","",""]
[null,7,"","","","","","","","","","","","","","",null,"","","",""]
[null,8,"","","","","","","","","","","","","","",null,"","","",""]
[null,9,"","","","","","","","","","","","","","",null,"","","",""]
[null,10,"","","","","","","","","","","","","","",null,"","","",""]
[null,11,"","","","","","","","","","","","","","",null,"","","",""]
[null,12,"","","","","","","","","","","","","","",null,"","","",""]
[null,13,"","","","","","","","","","","","","","",null,"","","",""]
[null,14,"","","","","","","","","","","","","","",null,"","","",""]
[null,15,"","","","","","","","","","","","","","",null,"","","",""]
[null,16,"","","","","","","","","","","","","","",null,"","","",""]
[null,17,"","","","","","","","","","","","","","",null,"","","",""]
[null,18,"","","","","","","","","","","","","","",null,"","","",""]
[null,19,"","","","","","","","","","","","","","",null,"","","",""]
[null,20,"","","","","","","","","","","","","","",null,"","","",""]
[null,21,"","","","","","","","","","","","","","",null,"","","",""]
[null,22,"","","","","","","","","","","","","","",null,"","","",""]
[null,23,"","","","","","","","","","","","","","",null,"","","",""]
[null,24,"","","","","","","","","","","","","","",null,"","","",""]
[null,25,"","","","","","","","","","","","","","",null,"","","",""]
[null,26,"","","","","","","","","","","","","","",null,"","","",""]
[null,27,"","","","","","","","","","","","","","",null,"","","",""]
[null,28,"","","","","","","","","","","","","","",null,"","","",""]
[null,29,"","","","","","","","","","","","","","",null,"","","",""]
[null,30,"","","","","","","","","","","","","","",null,"","","",""]
[null,31,"","","","","","","","","","","","","","",null,"","","",""]
[null,32,"","","","","","","","","","","","","","",null,"","","",""]
[null,33,"","","","","","","","","","","","","","",null,"","","",""]
[null,34,"","","","","","","","","","","","","","",null,"","","",""]
[null,35,"","","","","","","","","","","","","","",null,"","","",""]
[null,36,"","","","","","","","","","","","","","",null,"","","",""]
[null,37,"","","","","","","","","","","","","","",null,"","","",""]
[null,38,"","","","","","","","","","","","","","",null,"","","",""]
[null,39,"","","","","","","","","","","","","","",null,"","","",""]
[null,40,"","","","","","","","","","","","","","",null,"","","",""]
[null,41,"","","","","","","","","","","","","","",null,"","","",""]
[null,42,"","","","","","","","","","","","","","",null,"","","",""]
[null,43,"","","","","","","","","","","","","","",null,"","","",""]
[null,44,"","","","","","","","","","","","","","",null,"","","",""]
[null,45,"","","","","","","","","","","","","","",null,"","","",""]
[null,46,"","","","","","","","","","","","","","",null,"","","",""]
[null,47,"","","","","","","","","","","","","","",null,"","","",""]
[null,48,"","","","","","","","","","","","","","",null,"","","",""]
[null,49,"","","","","","","","","","","","","","",null,"","","",""]
[null,50,"","","","","","","","","","","","","","",null,"","","",""]
[null,51,"","","","","","","","","","","","","","",null,"","","",""]
[null,52,"","","","","","","","","","","","","","",null,"","","",""]
[null,53,"","","","","","","","","","","","","","",null,"","","",""]
[null,54,"","","","","","","","","","","","","","",null,"","","",""]
[null,55,"","","","","","","","","","","","","","",null,"","","",""]
[null,56,"","","","","","","","","","","","","","",null,"","","",""]
[null,57,"","","","","","","","","","","","","","",null,"","","",""]
[null,58,"","","","","","","","","","","","","","",null,"","","",""]
[null,59,"","","","","","","","","","","","","","",null,"","","",""]
[null,60,"","","","","","","","","","","","","","",null,"","","",""]
[null,61,"","","","","","","","","","","","","","",null,"","","",""]
[null,62,"","","","","","","","","","","","","","",null,"","","",""]
[null,63,"","","","","","","","","","","","","","",null,"","","",""]
[null,64,"","","","","","","","","","","","","","",null,"","","",""]
[null,65,"",{"$f":"IF(B91<=$C$11,WEEKDAY(C91,2),\"\")","v":""},"","","","","",{"$f":"IF(B91>C$11,\"\",((1+C$16)^(F91/360)-1)*H91)","v":""},{"$f":"IF(B91>C$11,\"\",C$18*C$19)","v":""},{"$f":"IF(B91>C$11,\"\",C$20)","v":""},"",{"$f":"IF(B91>C$11,\"\",H91-I91)","v":""},{"$f":"IFERROR(IF(AND(MONTH(E91)=7,C$14=2),2/(1+C$17)^(G91/360),IF(AND(MONTH(E91)=12,C$15=2),2/(1+C$17)^(G91/360),1/(1+C$17)^(G91/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+C$17)^(G91/360),\"\")","v":""},null,"",{"$f":"G91","v":""},{"$f":"IFERROR((1+C$23)^(S91/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R91/T91,2),\"\")","v":""}]
[null,66,{"$f":"IF(B92>$C$11,\"\",EDATE(C91,1))","v":""},"",{"$f":"IF(D92=7,C92+1,C92)","v":""},{"$f":"IF(B92>C$11,\"\",E92-E91)","v":""},{"$f":"IFERROR(F92+G91,\"\")","v":""},{"$f":"IF(B92>C$11,\"\",N91)","v":""},{"$f":"IF(B92>C$11,\"\",M92-L92-K92-J92)","v":""},"","","",{"$f":"IF(B92>C$11,\"\",IF(B92=C$11,H92+J92+K92+L92,IF(AND(C$14=2,MONTH(E92)=7),2*C$21,IF(AND(C$15=2,MONTH(E92)=12),2*C$21,C$21))))","v":""},"","","",null,{"$f":"IFERROR(I92+J92+K92+L92,\"\")","v":""},"","",""]
[null,67,"","","","","","","","","","","","","","",null,"","","",""]
[null,68,"","","","","","","","","","","","","","",null,"","","",""]
[null,69,"","","","","","","","","","","","","","",null,"","","",""]
[null,70,"","","","","","","","","","","","","","",null,"","","",""]
[null,71,"","","","","","","","","","","","","","",null,"","","",""]
[null,72,"","","","","","","","","","","","","","",null,"","","",""]